---
title: SAIF.Business.Tasks SQL catalog
summary: Index of all SQL statements used by this library, grouped by operation type.
status: draft
owner: SAIF Documentation
last_reviewed: 2026-08-21
library: SAIF.Business.Tasks
reference_type: embedded
---

# SAIF.Business.Tasks SQL catalog

This page indexes all SQL statements and stored procedure calls in this library, grouped by CRUD type.

## Create operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-001](SQL-001-insert-task.md) | Insert a new task record | Stored Proc | N/A — stored procedure (writes `TASK`)** | `clsTask` |

## Read operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-002](SQL-002-select-task.md) | Retrieve a single task by sequence number | Stored Proc | N/A — stored procedure (reads `TASK`)** | `clsTask` |
| [SQL-003](SQL-003-select-task-action-code.md) | Retrieve one action code by code value | Inline | `TASK_ACTION_CODE` | `clsTaskActionCode` |
| [SQL-004](SQL-004-select-task-action-code-list.md) | Retrieve all action codes | Inline | `TASK_ACTION_CODE` | `clsTaskActionCodeCollection` |
| [SQL-005](SQL-005-valid-source-category-check.md) | Count matching source/category combinations for validation | Inline | `TASK_CATEGORY_CODE` | `clsTaskBusinessRules` |
| [SQL-006](SQL-006-select-task-category-code.md) | Retrieve one category code by code and source system | Inline | `TASK_CATEGORY_CODE` | `clsTaskCategoryCode` |
| [SQL-007](SQL-007-select-task-category-code-list.md) | Retrieve all category codes for a source system | Inline | `TASK_CATEGORY_CODE` | `clsTaskCategoryCodeCollection` |
| [SQL-008](SQL-008-retrieve-filtered-task-list.md) | Retrieve tasks matching dynamic search criteria | StringBuilder-assembled | `TASK` | `clsTaskCollection` |
| [SQL-009](SQL-009-select-task-priority-code.md) | Retrieve one priority code by code value | Inline | `TASK_PRIORITY_CODE` | `clsTaskPriorityCode` |
| [SQL-010](SQL-010-select-task-priority-code-list.md) | Retrieve all priority codes | Inline | `TASK_PRIORITY_CODE` | `clsTaskPriorityCodeCollection` |
| [SQL-011](SQL-011-select-task-source-code.md) | Retrieve one source code by code value | Inline | `TASK_SOURCE_CODE` | `clsTaskSourceCode` |
| [SQL-012](SQL-012-select-task-source-code-list.md) | Retrieve all source codes | Inline | `TASK_SOURCE_CODE` | `clsTaskSourceCodeCollection` |

## Update operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-013](SQL-013-update-task.md) | Update an existing task's mutable fields | Stored Proc | N/A — stored procedure (writes `TASK`)** | `clsTask` |

## Delete operations

| SQL ID | Description | Type | Tables | Business object |
| --- | --- | --- | --- | --- |
| [SQL-014](SQL-014-delete-task.md) | Complete (soft-delete) a task | Stored Proc | N/A — stored procedure (writes `TASK`)** | `clsTask` |
| [SQL-015](SQL-015-purge-tasks.md) | Purge completed tasks past the retention window | Stored Proc | N/A — stored procedure (deletes from `TASK`)** | `clsTaskCollection` |

## Related documentation
- [Index](../index.md)
- [Overview](../overview.md)
- [Architecture](../architecture.md)
- [Dependencies](../dependencies.md)
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [Database tables](../database-tables.md)
- [Procedures](../procedures/index.md)
- [API reference](../api/index.md)

> **Note:** Statements marked with * were inferred from code structure, naming conventions, or
> contextual evidence where direct confirmation was not available in source artifacts. Statements
> marked with ** could not be confirmed; treat as unknown until verified.

## Sources
- SAIF.Business.Tasks/clsTask.vb
- SAIF.Business.Tasks/clsTaskCollection.vb
- SAIF.Business.Tasks/clsTaskBusinessRules.vb
- SAIF.Business.Tasks/clsTaskActionCode.vb
- SAIF.Business.Tasks/clsTaskActionCodeCollection.vb
- SAIF.Business.Tasks/clsTaskCategoryCode.vb
- SAIF.Business.Tasks/clsTaskCategoryCodeCollection.vb
- SAIF.Business.Tasks/clsTaskPriorityCode.vb
- SAIF.Business.Tasks/clsTaskPriorityCodeCollection.vb
- SAIF.Business.Tasks/clsTaskSourceCode.vb
- SAIF.Business.Tasks/clsTaskSourceCodeCollection.vb